Apparatus for automatically applying and preparing software, and recording medium for preparing software

ABSTRACT

When data is simply input without being aware of describing a program language (e.g., COBOL or FORTRAN), the data input meaning is detected, and software for this data processing is automatically applied and prepared. Various types of worksheets corresponding to the business logic terms and data input positions are stored in a business data file. When an operation unit is operated and data is input to the data input position, the input data is stored as rule setting data. When application data corresponding to the rule setting data is input through the operation unit, a business logic applying section determines the use software in accordance with the corresponding business logic term.

BACKGROUND OF THE INVENTION

The present invention relates to an apparatus and software recordingmedium which can detect the meaning of input data when a businessmansimply enters data without being aware of the conventionally practiceddescription of a program language (e.g., COBOL and FORTRAN) inaccordance with a flow chart in preparing software and, moreparticularly, to an apparatus for automatically applying and preparingsoftware and a recording medium for preparing software, capable ofautomatically selecting and applying software for processing the inputdata in accordance with the meaning of the input data upon detecting themeaning of the input data.

To conventionally create software, a routine for applying this softwareis designed in a flow chart, the program language is described inaccordance with the flow chart, and the program language is then encodedinto the machine language.

According to this method, however, the program language must be checkedas a whole and corrected when the programmer wants to change settingconditions and dates in software data processing. Therefore, it takestime to change the design of the program, or jobs by specialists arerequired.

Even a simple change in processing contents and conditions of theconventional program becomes expensive, takes time, and requires thejobs of specialists.

BRIEF SUMMARY OF THE INVENTION

It is, therefore, an object of the present invention to provide anapparatus for automatically applying and preparing software and arecording medium for preparing software, capable of automaticallyapplying and preparing data processing software by detecting the meaningand contents of a data input when the user simply inputs the datawithout being aware of the description of a program language (e.g.,COBOL or FORTRAN).

In order to achieve the above object according to the present invention,there is provided an apparatus for applying and preparing software,comprising a file storing various kinds of business worksheets eachincluding at least one business logic term representing a minimum unitin a business operation, rule setting means for displaying a given oneof the business worksheets which corresponds to user selectioninformation on a display to indicate a data input position of the givenbusiness worksheet together with a corresponding business logic term, abusiness data file for, when data is input to the data input position,storing the input data as business rule setting data, using means forinputting application data corresponding to the business logic termstored in the business data file, and business logic applying means for,when the application data is input, determining software to be used incorrespondence with the business logic term corresponding to theapplication data, performing arithmetic processing by the determinedsoftware using the application data and the business rule setting datacorresponding to the application data, and obtaining an arithmeticprocessing result.

According to the above means, in designing a program, rule setting datais input to a data input position accompanying to a business logic termon a business worksheet. The rule setting data is made to correspond tosoftware for processing this rule setting data as reference data, on thebasis of the meaning of the business logic term. This operation is arule setting data input job for pursuing business operation rather thanprogram design operation.

When application data corresponding to the above rule setting data isinput in use of the apparatus, the application program is automaticallyselected and executed, thereby obtaining the processing resultrepresented by the business term.

According to the present invention, there is provided a recording mediumfor applying and preparing software, comprising a worksheet file sectionstoring various kinds of business worksheets each including at least onebusiness logic term representing the minimum unit in a businessoperation, rule setting software for displaying a given one of thebusiness worksheets which corresponds to user selection information on adisplay to indicate a data input position of the given businessworksheet together with a corresponding business logic term, a businessdata file section for, when data is input to the data input position,storing the input data as business rule setting data, first use softwarefor inputting application data corresponding to the rule setting datastored in the business data file section, and second use software for,when the application data is input, determining software to be used incorrespondence with the business logic term corresponding to theapplication data, performing arithmetic processing by the determinedsoftware using the application data and the business rule setting datacorresponding to the application data, and obtaining an arithmeticprocessing result.

In designing a program, the above recording medium is operated on thecomputer to allow the user to input rule setting data in a data inputposition accompanying to the business logic term on the businessworksheet. The rule setting data is made to correspond to software forprocessing this rule setting data as reference data.

When application data corresponding to the above rule setting data isinput in use of the computer, the application program is automaticallyselected and executed, thereby obtaining the processing resultrepresented by the business term.

Additional objects and advantages of the invention will be set forth inthe description which follows, and in part will be obvious from thedescription, or may be learned by practice of the invention. The objectsand advantages of the invention may be realized and obtained by means ofthe instrumentalities and combinations particularly pointed outhereinafter.

BRIEF DESCRIPTION OF THE SEVERAL VIEWS OF THE DRAWING

The accompanying drawings, which are incorporated in and constitute apart of the specification, illustrate presently preferred embodiments ofthe invention, and together with the general description given above andthe detailed description of the preferred embodiments give below, serveto explain the principles of the invention.

FIG. 1 is a block diagram showing the basic concept of the presentinvention;

FIG. 2 is a block diagram showing the overall arrangement of anembodiment of the present invention;

FIGS. 3A and 3B are views showing windows in use of an apparatus of thepresent invention;

FIG. 4 is a view showing the table of a business logic applying section;

FIG. 5 is a block diagram showing the detailed arrangement of theapparatus of the present invention;

FIGS. 6A to 6Z are tables of business logic applying section or datafile;

FIGS. 7A-1, 7A-2, 7B-1, 7B-2 and 7B-3 are tables of the business logicapplying section or data file;

FIGS. 8A-1, 8A-2, 8B-1, 8B-2 and 8B-3 are tables of the business logicapplying section or data file;

FIGS. 9A and 9B are tables of the business logic applying section ordata file;

FIG. 10 is a flow chart of an operation routine when the apparatus ofthe present invention is used;

FIG. 11 is a flow chart of another operation routine when the apparatusof the present invention is used;

FIG. 12 is a flow chart of still another operation routine when theapparatus of the present invention is used;

FIGS. 13A to 13C are block diagrams showing apparatuses according toother embodiments of the present invention;

FIG. 14 is a block diagram of another business data file of theapparatus of the present invention;

FIGS. 15A and 15B are views showing other display examples of theapparatus of the present invention;

FIGS. 16A and 16B are views showing window examples in use of theapparatus of the present invention;

FIGS. 17A and 17B are views showing other window examples in use of theapparatus of the present invention;

FIGS. 18A and 18B are views showing still other window examples in useof the apparatus of the present invention;

FIGS. 19A and 19B are views showing still other window examples in useof the apparatus of the present invention; and

FIGS. 20A and 20B are views showing the still other window examples inuse of the apparatus of the present invention.

DETAILED DESCRIPTION OF THE INVENTION

The preferred embodiments of the present invention will be described indetail with reference to the several views of the accompanying drawing.

FIG. 1 shows an embodiment of the present invention. Reference numeral100 denotes a computer main body constituted by hardware and anoperation system (OS). Reference numeral 500 denotes a display; and1000, a new working apparatus of the present invention, which isconstituted by a recording medium and its drive unit (to be describedlater), or an IC logic block.

FIG. 2 shows the details of the embodiment of the present invention. Thecomputer main body is constituted by hardware and the operation system(OS). A business logic applying section 200 is mounted in the computermain body 100. The business logic applying section 200 is constituted bya business operation system (business OS) 201 and a business rulematching/check section 202.

The business operation system (business OS) is predetermined softwaresuch as presence check software, upper limit check software, lower limitcheck software, and total amount processing software. These softwareprograms are used as common software programs for various processingoperations.

The business rule matching/check section 202 serves as a determinationsection for determining which software is used when business operationsystem software is used on the basis of the business logic terms of abusiness worksheet in data processing (to be described later).

The business worksheets, business logic terms, and rule setting data arestored in a business data file 400. The business data file 400 stores,as data, various types of worksheets such as a rule setting register, aslip, and a plan for rule setting required in business operations, and aslip, a book and slip, an order slip, a settling slip used indistribution business. Each worksheet includes at least one businesslogic term representing the minimum unit in a business operation.

A data input position is present in correspondence with the businesslogic term. In designing a program, when data is input to the data inputposition of a plan or a rule setting worksheet, this input data servesas rule setting data. Upon inputting the rule setting data, when data isinput to a data input position of a worksheet such as a ruleconfirmation or estimate in use of a computer in a business operation,this data serves as application data.

The display 500 displays a worksheet when a program is to be created orused upon creation of the program. The display 500 is used to confirmthe user data input or the program processing result. In preparing andusing a program, an overall management section 600 operates in responseto an input operation from the operation unit and accesses peripheralblock data or starts the peripheral block. At the same time, the overallmanagement section 600 controls data input/output timings.

In response to the operation input through the overall managementsection 600, a display controller 300 determines a specific one of theworksheets to be displayed. The display controller 300 reads out datafrom the business data file 400. Data accompanying to the readoutworksheet is also read out. The readout data and worksheet aretransmitted through the overall management section 600 and displayed onthe display 500.

For example, the worksheet describes business logic terms, as shown inFIG. 3. Data can be filled in blank portions (data input positions)corresponding to these business terms. This example is a worksheet withwhich a credit amount is set for a client. The title “Description ofCredit Amount for Client” is set in this worksheet. To read out thisworksheet, an operation called the start of program preparation (orbusiness rule setting) is performed from an operation unit 501. Forexample, if the menu requests a desired title, the title menucorresponding to the request appears. The user refers to the title menuand clicks the title “Description of Credit Amount for Client”.Therefore, the worksheet is displayed on the display.

The overall management section 600 activates the system and responds toan input from the operation unit 501.

Since the data processing contents corresponding to the item“Description of Credit Amount for Client” are predetermined, thebusiness logic applying section 200 has data representing thecorrelation between software for performing this data processing and theworksheet.

In the display state shown in FIG. 3A, the client number and the companyname are input. This worksheet also has columns of the date of start ofapplication, the date of end of application, the credit amount, and thestop of application. Necessary data are filled in these columns,respectively. In this example, the date of start of application is Jun.6, 1997, and the credit amount is 200,000,000. No data are filled in thecolumns of the date of end of application and the stop of application.When no data are filled, data processing for these business logic itemsare not automatically performed.

A worksheet for creating a sales merchandise list of a client is alsostored in the business logic applying section 200. Various types of dataof the client (these data are called business rule setting datahereinafter) can be created.

When necessary rule setting data are filled in the necessary worksheet,the end of window display is clicked. Each worksheet is stored in thebusiness data file 400. Since the necessary data processing in abusiness operation is predetermined depending on the types (contents) ofthe rule setting data, a program to be applied to each data can bedetermined upon the data input.

In actual use of the computer, when application data is input to check aclient for, e.g., the above-mentioned credit amount, it must bedetermined whether the application data is appropriate. The upper limitcheck processing is performed by comparing the application data with thepreviously input credit amount (business setting data) and bydetermining whether the amount represented by the application dataexceeds the value of the business rule setting data.

More specifically, according to the present invention, businessapplication software is perfectly separated into business logic andprogram logic (computer logic) in accordance with a predeterminedreference, and the arrangement of the apparatus is considered based onthis separation. Elements of the predetermined reference are slips andreferences. And computer windows, computer books, slips for businessworksheets (business documents) and items expressed in the worksheetsare made.

Further the business data are classified into a business transactionknow-how data group (meaningful minimum unit elements for determiningthe contents of a business contract and the like), a basic businessoperation data group (meaningful minimum unit elements such as companyrules for pursuing the contract), and an account data group (meaningfulminimum units such as accounting processing rules based on theCommercial Code, the tax law, the commercial transaction law). Thesedata groups are made to corresponding to application software programsfor processing these data groups. More specifically, the data groups aremade to correspond to application software programs such as an upperlimit check program, a lower limit check program, a presence checkprogram, and an total amount processing program.

The data are separated and arranged as described above. Only themechanism for processing the above items is left as the program logic toconstitute the application software. This is the business OS. Thesebusiness items are simple data if their contents are known. These arebusiness data.

The software (business OS) stored in the business logic applying meansis a software group for performing upper limit check processing, thelower limit check processing, the presence check processing, and thetotal amount processing using the application data (i.e., data inputwhen the apparatus of the present invention is used in actual businesstransaction and the corresponding business rule setting data (datastored as a database in advance).

Referring back to FIG. 3, a database using a worksheet is prepared. Theabove example is the case in which the credit amount is set for a givenclient. In addition, a client company list database, database of salesmerchandise for clients, data of unit prices and quantity information ofthe sales merchandise can also be prepared.

FIG. 3B shows an application window when a client, ABCDE Co. made anorder. In this case, an application worksheet is read out as theworksheet. As shown in FIGS. 3A and 3B, accessed information is input toeach necessary position. More specifically, the client code, the clientname, the merchandise code, the unit price, the quantity, and the amountof order received are input. When these data are input, the start isinstructed. The apparatus is switched to the application mode by theoperation unit 501, and the user requests the menu of the aboveapplication window for its worksheet. The display controller 300displays the title of the application worksheet. When a desired title,i.e., “order reception” is present, the user clicks the title.

The application window shown in FIG. 3B is obtained on the display 500.The user then inputs data. When the start of inquiry is operated by theuser, it is determined whether the amount of order received exceeds thecredit amount (upper limit check processing). At this time, the softwareis executed as follows. The business logic applying unit 200 detects theitem defined as the amount of order received, automatically selects theupper limit check processing software, and then executes this software.The resultant data is displayed as “within the credit amount” or “overthe credit amount” is displayed on the display 500 through the displaycontroller 300 and the overall management section 600.

FIG. 4 shows a correlation table among the worksheets, the businesslogic terms described in the worksheets, the worksheet group data inwhich the business logic terms are present, and application software.The business data file 400 or the business logic applying section 200has this correlation table to detect the worksheet currently accessed onthe display 500, detects the corresponding business logic term when datais input, and determines the application software. Data obtained uponapplying the software is fed back as a window on the display again. Thetable in FIG. 4 can be described in either the business logic applyingsection 200 or the business data file 400.

The above embodiment has described the basic principle of the presentinvention. The present invention is not limited to the above embodiment.The business logic terms are merely examples. All the items such asvarious types of slips, books and slips, and settling slips correspondto the business logic terms of the present invention. These terms areused as the references that the business logic applying section selectsappropriate software.

FIG. 5 is a block diagram showing the detailed arrangement of thepresent invention.

The same reference numerals as in FIG. 2 denote the same parts in FIG.5. The data in the business data file 400 in FIG. 2 are classified usingthe worksheet and the data applied to the items described in thisworksheet.

In addition, the data in FIG. 5 are classified in accordance with thenatures. The data natures are classified into frequently updated simpledata and semipermanent data. In FIG. 5, the simple data are collected ina business data recording section, while the semipermanent data arecollected in a control data recording section.

The data in the business data recording section are further classified,depending on the types, into a business transaction recording section, abusiness operation recording section, and a rule (e.g., variousregulations) recording section.

When these data are updated, the results are left as a record (history).

The transaction time, the company, and the contents of a transaction areleft as a business transaction record. The operation proceeding data,the accounting history data, and the personnel management history dataare recorded as a business operation record. Various regulation data(e.g., data before and after changes in office regulation) and databefore and after changes in credit amount of a client company arerecorded as a business rule record. Information representing a change inpurchase quantity of merchandise of a client company, and the like arealso recorded in the business data recording section. The business datarecording section also serves as a recording section for recording avalue of a special sales merchandise sold at a discount.

The data in the control data recording section are classified, dependingon the types, into a rule applying regulation recording section, awindow layout recording section, and a book and slip layout recordingsection. As described with reference to FIG. 4, the logic term of aworksheet, and a table representing the relationship between the logicterm and the associated software are described in the rule applyingsection.

In the above description, for better understanding of functions, theoverall management section 600, the business logic applying section 200,and the display controller 300 are illustrated as the separate blocks,but may be integrated with each other.

In the above system, the rule setting data input position for inputtingthe date of application as the business logic term for setting thebusiness rule is present on the worksheet. That is, the worksheet hastime axis information which is effectively utilized. The date of startof application and the date of end of application are present for thelapse of time and the date of application. The data input positions arepresent for these items. To input the date of application, a means forrequesting a password key input concomitently operates in the rulesetting means.

The operation unit 501 can be immediately operated to change the rulesetting data in the presence of these functions when the user wants tostop business transactions with a plurality of client companies or tostop importing some merchandise from a supplier. For this reason, theoperation speed in business operations can increase. When this system isapplied to business operations, business operation management has highreliability, and the system has a high utilization value. In addition,the system can immediately cope with a change of rate in foreigncurrency.

Since the business rule data representing the past rule records arepresent in this system, data currently accessed at a past rate can beeasily calculated.

From FIG. 6A, the detailed tables of business operations arranged in thebusiness logic applying section 200 are shown. The correlation tablesamong the respective business operation processing, the businessoperation contents, windows to be used, the books on which data are tobe recorded, and ledgers.

FIGS. 6A to 6Z show business operation processing standards. The columnsof each standard has computer business operation processing (businessoperation processing minimum unit reference/computer business operationprocessing reference), a rule setting business operation, a commercialtransaction operation, a distribution operation, a circulationoperation, a manufacturing operation, slips (slip fillingreference/window design reference) for recording basic businessoperations, books/slips/ledgers for recording basic business operations,a Commercial Code reference, an accounting reference, a tax reference,and a securities exchange reference are sequentially formed from theleft column. A circle in each column represents a flag.

For example, the columns having No. 17 in FIG. 6B describe theprocessing contents for opening the transaction account of a client. Toexecute this processing is to execute rule setting business operation.An item representing the opening of the transaction account of a clientis clicked in the menu. An account-opening slip for the transactionaccount is displayed in the window in order to open the account. Theuser operates the apparatus while viewing the window, so that the datadescribed in this slip is described in a client book (file) as clientdata. When the data is added as described above, the Commercial Codereference, the accounting reference, the tax reference, and thecommercial transaction reference are applied. The following meaning isdescribed in the columns having No. 79 in FIG. 6G. No. 79 represents theshipping instruction of sales merchandise. This belongs to thecommercial transaction operation. When a shipping instruction is to beissued, the note of shipment of the sales merchandise is read on thewindow, and the operator enters data (e.g., permission and quantity).This data is described in the shipping instruction register. The stockor the like can be calculated when using the input data (e.g.,permission and quantity). Software for processing this data (e.g.,permission and quantity) can be determined. For example, inventoryprocessing of the sales merchandise having No. 111 in FIG. 6I can beexecuted using the determined software.

A database associated with each business operation can be prepared bypreparing the business operation processing standard table as describedabove. In addition, software can be automatically determined when thedata of such a database are used. A program for associating these datawith software is stored in, e.g., the overall management section 600.

FIGS. 7A-1 to 8B-3 show the tables of contents (rules) by which theapparatus of the present invention operates in performing an orderreception operation and an ordering operation. FIGS. 7A-1, 7A-2, 7B-1,7B-2, and 7B-3 represent one table, and FIGS. 8A-1, 8A-2, 8B-1, 8B-2,and 8B-3 represent one table. This table has the columns of businessoperation processing rule, business operation processing rule logic,business operation processing rule application item, and businessoperation rule check item from the left column. For example, whenconfirmation of purchase merchandise having No. 1 in FIG. 7A-1 isselected from the menu, it is checked if the purchase merchandise ispurchasable. A window for inputting the name of the purchase merchandiseand its code is displayed in the window. When the user inputsappropriate data while watching the window, the check is started on thebasis of the determination in the business logic applying section 200. Asupplier, and the presence of a supplier organization are automaticallychecked while referring to the database. When confirmation of theappropriate stock of the purchase merchandises having No. 6 and whetherthe total stock is proper are selected, the appropriate stock ofpurchase merchandises is checked. At this time, the user inputs thequantity of order in the item, “order purchase merchandise” appearing inthe window. The total stock is automatically checked. This check is theupper limit check to determine whether the quantity of order exceeds thetotal stock. In addition, it is also checked if this purchasemerchandise is stocked.

FIGS. 9A and 9B show a business rule table applied to confirm thepresence of a person in charge in ordering or order reception. FIGS. 9Aand 9B constitute one table.

In the above table, some items are exemplified, but other items can alsobe used in the same manner as described above.

User's operation of the apparatus of the present invention wheninstalling the apparatus will be briefly described below.

The new working apparatus can be prepared by a data control typebusiness application recorded on, e.g., a recording medium. Theapplication is installed in the computer main body using a setupprogram.

FIG. 10 shows an operation example in the preparation stage in which theapparatus of the present invention is used in business operations.Overall unit management is performed by the overall management section600, and the operation order of the respective units, data search, dataoutput, and the like are controlled by the overall management section600.

In the preparation stage, items whose flags are set in the columns ofthe rule setting operations in the tables from FIG. 6B are processed.For example, assume that the operation unit is operated to use theapparatus for business operation working. A business operation workingwindow (worksheet) for preparing for a data file is displayed on thedisplay from a working preparation menu (steps a1 and a2). While viewingthe window, the user inputs business setting data in the black portionsof appropriate items (step a3) to prepare a business operation datafile. A similar processing routine is executed to set a businessoperation rule.

FIG. 11 shows an operation example for using a data base (control data)thus prepared. In a business operation menu display state, when the userselects a target item in the menu (step b1), the window is changed to abusiness operation processing window (step b2) corresponding to theselected item. The user inputs necessary data while viewing the businessoperation processing window (b3). The business logic applying section200 intelligently determines necessary software using the tables shownin FIGS. 6A-1 to 9B in accordance with the types of input data, anddisplays the processing result (step b4). The user retries the operationupon checking the processing result or enters OK (step b5).

FIG. 12 shows a processing sequence used when a business operation rulemust be changed. When the user operates the business operation rulechange key, a prompt is displayed to input a password with keys (c1 andc2). This aims at preventing anybody from arbitrarily changing the rule.When the password is input, a preparation menu is displayed as in theabove preparation. The user selects an item for changing the rule fromthe displayed menu (step c3). When the business operation rule settingwindow appears, condition data is input to a necessary portion (stepc5).

Several examples will be described below.

(1) Check of Account of Client in Order Reception Operation

(a) Preparation for Order Reception . . . the client is registered inthis preparation.

(b) Actual Order Reception Operation Time . . . it is checked if theclient is registered in advance.

(2) Check of Credit Amount in Order Reception Operation

(a) Preparation for Order Reception . . . the client is registered, andits credit amount is registered.

(b) Actual Order Reception Operation Time . . . it is checked if the sumof the account receivable of the client and the amount of order exceedsthe credit amount.

(3) Check of Authority of Person in Charge in Order Reception Operation

(a) Preparation for Order Reception . . . the person in charge isregistered, and the upper limit amount of the sales authority of theperson in charge is registered.

(b) Actual Order Reception Operation Time . . . it is checked if thetotal amount of order received exceeds the upper limit amount of thesales authority of the person in charge.

The present invention is not limited to the above embodiment, variouschanges and modifications can be made.

FIG. 13A shows an arrangement in which a display 500 and a new workingapparatus 1000 are connected through data transmission/reception units(modems) 701 and 702. With this arrangement of the apparatus, businessdata processing and business rule setting can be performed at a remotelocation through the network. In this case, software for controlling thetransmission/reception unit 701 is installed on the recording medium orin the hardware of the new working apparatus.

According to the present invention, the new working apparatus 1000 andthe computer main body 100 may be arranged in a server on the network.

FIG. 13B shows an arrangement in which a new working apparatus 1000 anda computer main body 100 are arranged in a server 200 on the network.The new working apparatus 1000 can be accessed from a terminal 500Ahaving a display and an operation unit. The new working apparatus 1000can also be accessed from a terminal 500B through the server 201. Inthis case, each terminal must have a modem.

With the above arrangement, when the new working apparatus 1000 canissue identification codes to the respective terminals and canindividually process the data from the terminals, the new workingapparatus 100 can be shared by a plurality of different companies.

FIG. 13C shows an arrangement in which a new working apparatus 1000 anda computer main body 100 are integrated with a personal computer 3000having a display, an operation unit, and a modem. The program-installedpersonal computer 3000 is connected to other personal computers 3001 and3002 through a network. By preparing this network, the user can use thepersonal computers 3001 and 3002 as if the new working apparatus 1000were owned by the personal computers 3001 and 3002.

FIG. 14 shows various business data files. The business data files areprepared in a plurality of languages as languages used in these filesand appearing in the windows of the display. With this arrangement, thesystem of the present invention can be used in all countries in theworld. In this case, an overall management section 600 has a languageselection function, and the user can set a desired language through anoperation unit 501.

The present invention is not limited to the above embodiment. Thedisplay controller 300 also has a function of displaying a plurality ofbusiness operation processing windows (worksheets) on the display 500.More specifically, as shown in FIG. 15A, for example, slips 1, 2, and 3can be displayed and processed in comparison. When data are input todata input positions of a worksheets, the priority of data processingmay be determined in advance or the processing order may be determinedin accordance with operations. As indicated by the hatched portions inFIG. 15B, for example, a slip may have a plurality of items, and theitems may serve as a plurality of data input positions. In this case,the data processing order may be determined by the user or automaticallydetermined. No data processing is performed for a blank portion havingno data, as a matter of course.

The use examples of the apparatus of the present invention will befurther described below.

FIG. 16A shows a rule setting window for setting a presence check rule.FIG. 16B shows a presence check application window. The rule settingwindow has a supplier code, a supplier name, the date of start oftransaction, the date of end of transaction, and the stop ofapplication.

Assume that the order No., the date of order, and the supplier code areinput as 0501, Jun. 6, 1995, and 0300, respectively. Since this supplieris present in the data file and the date of start of transaction isappropriate, an order can be made. The information of the supplier,merchandise codes, and merchandise names are displayed. At this time, ifno supplier is present, or the date of end of transaction has passed, analarm message or sound is generated.

FIG. 17A shows a rule setting window when the rule is set for checkingthe upper limit of the sales amount authority of the person in charge.FIG. 17B shows the upper limit check application window. The rulesetting window has, as items, the date of start of application, the dateof end of application, the sales amount authority, and the stop ofapplication. Assume that the person in charge inputs theperson-in-charge code as 95010, the order reception date as Jan. 30,1997, the client as X company, merchandise codes, merchandise names,quantities, unit prices, and the like in the order reception applicationwindow. In the application window, spreadsheet software is automaticallyoperated to calculate the total amount. Check software is then operatedto check if the total amount falls within the sales amount authority andif the date of application is appropriate. In the illustrated example,nothing appears or no alarm is generated because all the input data areappropriate.

FIG. 18A shows a rule setting window for setting a rule upon describingthe number of days required for merchandise delivery. FIG. 18B shows alower limit check application window. The rule setting window has, asitems, the merchandise code, the merchandise name, the date of start ofapplication, the date of end of application, the number of days requiredfor merchandise delivery, and the stop of application. Assume that theperson in charge inputs the order reception date as Jul. 7, 1997, thedate of delivery as Jul. 10, 1997, the merchandise code, the merchandisename, the quantity, and the unit price in the order receptionapplication window. In this case, the merchandise code is confirmed, andthe sum of the order reception date and two days (the number of daysrequired for delivery) is calculated as Jul. 9, 1997. The date ofdelivery desired by the user is Jul. 10, 1997. The lower limit checkprocessing is then performed to determine that the order reception isallowed.

FIG. 19A shows a rule setting window for setting a rule for amerchandise sales set as an example of unit check. FIG. 19B shows anorder reception application window. The rule setting window has, asitems, the merchandise code, the merchandise name, the date of start ofapplication, the date of end of application, the sales set, and the stopof application. Data are then input to these items.

Assume that the order reception date, the merchandise code, and thequantity are input as Mar. 3, 1997, 4531213, and 100, respectively, inthe application window upon allowing order reception. In this case,since the input quantity is 100 which is twice 50, the order receptionis allowed.

FIG. 20A shows a rule setting window for describing merchandise unitprices for the respective quantities. This processing belongs to editprocessing. The rule setting window has, as items, the merchandise code,the merchandise name, the date of start of application, the date of endof application, the quantity range, the unit price, and the stop ofapplication.

Assume that the order reception date, the merchandise code, and thequantity are input as Jun. 1, 1997, 4531213, and 250, respectively inthe application window. In this case, the order reception can be allowedwithout any problem. If the quantity is 205, the unit price is given as¥90 according to the rule setting data. Data “90” is read out anddisplayed in the column of unit price. The arithmetic function isperformed to calculate 90×250, and “22,500” is displayed in the columnof amount.

In addition, according to the apparatus of the present invention, dataprocessing of the same contents can be performed for a plurality ofitems in different conditions.

For example, when merchandise sales quantity data is present, anexchange table representing the business results in dollar, yen, andmark can be easily displayed using the business result sheet as theapplication window. This processing can be performed using the commonprogram for executing the exchange rule because only the exchangeconditions (rate coefficients) are different. The merchandise salesquantity data is input to the input position of the sales quantity inthe business result sheet, and yen, dollar, or mark is set in thecondition input position. When the apparatus of the present invention isused as described above, for example, a plurality of business resultsheets are displayed, and the business results obtained upon exchange inyen, dollar, and mark can be simultaneously checked in the same window.

The above rule setting windows and application windows are merelyexamples. Various changes and modifications may be made within thespirit and scope of the invention.

In the above description, the new working apparatus 1000 is installed inthe computer system using a recording medium such as an optical disk toprepare the respective processing routines. The present invention,however, is not limited to this. The new working apparatus 1000 itselfis prepared as hardware constituting the business logic applying section200, the display controller 300, the overall management section 600. Inaddition, the business data file 400 may be constituted by a hardwarememory, and this portion may be constituted as a detachable recordingmedium such as a disk. When the business data file section is detachablyarranged, it can be replaced with a new one in the change and correctionof design and layout of a worksheet.

As has been described above, when the user simply inputs data withoutbeing aware of a program language (e.g., COBOL or FORTRAN), the inputdata meaning is detected, and software for this data processing can beautomatically applied and prepared. Immediate response processing isallowed in accordance with the setting data input. Software recheck orcorrection need not be performed.

Additional advantages and modifications will readily occurs to thoseskilled in the art. Therefore, the invention in its broader aspects isnot limited to the specific details and representative embodiments shownand described herein. Accordingly, various modifications may be madewithout departing from the spirit or scope of the general inventiveconcept as defined by the appended claims and their equivalents.

What is claimed is:
 1. An apparatus for applying and preparing software, comprising: a worksheet file storing various kinds of business worksheets each including at least one business logic term which represents a minimum unit in a business operation and is prepared in a plurality of languages as display data, said business worksheets including rule setting worksheets for inputting business rule setting data and application data inputting worksheets for inputting application data; rule setting means for displaying a given one of the rule setting worksheets which corresponds to user selection information on a display, on which a rule setting data input position of the given rule setting worksheet is indicated by a corresponding business logic term in such a manner that a user can input the business rule setting data to said rule setting data input position and change the business rule setting data in said rule setting data input position; a business data file for, when data is input to the rule setting data input position, storing the input data as business rule setting data together with the corresponding business logic term; first using means for displaying a given one of the application data inputting worksheets which corresponds to user selection information on the display, on which an application data input position of the given application data inputting worksheet is indicated by a corresponding business logic term; second using means for inputting application data corresponding to the business logic term stored in said business data file into the application data input position; and business logic applying means for, when the application data is input, determining software to be used in correspondence with the business logic term corresponding to the application data, performing arithmetic processing by the determined software using the application data and the business rule setting data corresponding to the application data, and obtaining an arithmetic processing unit and thereby supporting a business work of the user.
 2. An apparatus according to claim 1 wherein a data processing order is predetermined when the application data is input to the application data input positions.
 3. An apparatus for applying and preparing software, comprising: a worksheet file storing various kinds of business worksheets each using at least one business logic term representing a minimum unit in a business operation and is prepared in a plurality of languages as display data, said business worksheets including rule setting worksheets for inputting business rule setting data and application data inputting worksheets for inputting application data; rule setting means for displaying a given one of the rule setting worksheets which corresponds to user selection information on a display, on which a rule setting data input position of the given rule setting worksheet is indicated by a corresponding business logic term in such a manner that a user can input the business rule setting data to said rule setting data input position and change the business rule setting data in said rule setting data input position, said rule setting data input position having positions for inputting a date of start of application and a date of end of application; a business data file for, when data is input to the rule setting data input position, storing the input data as business rule setting data together with the corresponding business logic term; first using means for displaying a given one of the application data inputting worksheets which corresponds to user selection information on the display, on which an application data input position of the given application data inputting worksheet in indicated by a corresponding business logic term; second using means for inputting application data corresponding to the business logic term stored in said business data file into the application data input position; and business logic applying means for, when the application data is input, determining software to be used in correspondence with the business logic term corresponding to the application data, performing arithmetic processing by the determined software using the application data and the business rule setting data corresponding to the application data, obtaining an arithmetic processing result, and thereby supporting a business work of the user.
 4. An apparatus according to claim 3 wherein means for requesting a password input is concomitantly operated in said rule setting means in order to input the date of start of application and the date of end of application.
 5. A recording medium for applying and preparing software, comprising: a worksheet file section storing various kinds of business worksheets each using at least one business logic term which represents a minimum unit in a business operation and is prepared in a plurality of languages as display data, said business worksheets including rule setting worksheets for inputting business rule setting data and application data inputting worksheets for inputting application data; rule setting software for displaying a given one of the rule setting worksheets which corresponds to user selection information on a display, on which a rule setting data input position of the given rule setting worksheet is indicated by a corresponding business logic term in such a manner that a user can input the business rule setting data to said rule setting data input position and change the business rule setting data in said rule setting data input position; a business data file section for, when data is input to the rule setting data input position, storing the input data as business rule setting data together with the corresponding business logic term; first using software for displaying a given one of the application data inputting worksheets which corresponds to user selection information on the display, on which an application data input position of the given application data inputting worksheet is indicated by a corresponding business logic term; second using software for inputting application data corresponding to the business logic term stored in said business data file into the application data input position; and business logic applying software for, when the application data is input, determining software to be used in correspondence with the business logic term corresponding to the application data, performing arithmetic processing by the determined software using the application data and the business rule setting data corresponding to the application data, obtaining an arithmetic processing result, and thereby supporting a business work of the user.
 6. A medium according to claim 5, wherein a data processing order is predetermined when the application data is input to the application data input position.
 7. A recording medium for applying and preparing software, comprising: a worksheet file section storing various kinds of business worksheets each using at least one business logic term representing a minimum unit in a business operation and is prepared in a plurality of languages as display data, said business worksheets including rule setting worksheets for inputting business rule setting data and application data inputting worksheets for inputting application data; rule setting software for displaying a given one of the rule setting worksheets which corresponds to user selection information on a display, on which a rule setting data input position of the given rule setting worksheet is indicated by a corresponding business logic term in such a manner that a user can input the business rule setting data to said rule setting data input position and change the business rule setting data in said rule setting data input position, said rule setting data input position having positions for inputting a date of start of application and a date of end of application; a business data file for, when data is input to the rule setting data input position, storing the input data as business rule setting data together the corresponding business logic term; first using software for displaying a given one of the application data inputting worksheets which corresponds to user selection information on the display, on which an application data input position of the given application data inputting worksheet is indicated by a corresponding business logic term; second using software for inputting application data corresponding to the business logic term stored in said business data file into the application data input position; and business logic applying software for, when the application data is input, determining software to be used in correspondence with the business logic term corresponding to the application data, performing arithmetic processing by the determined software using the application data and the business rule setting data corresponding to the application data, obtaining an arithmetic processing result, and thereby supporting a business work of the user.
 8. A medium according to claim 7, wherein software for requesting a password input is concomitantly operated under an environment of said rule setting software in order to input the date of start of application and the date of end of application. 